﻿IF NOT EXISTS (SELECT 1 FROM SystemSettingValue WHERE SystemSettingName = 'WebPlusILPStudentURL')
BEGIN
	INSERT INTO	
		SystemSettingValue
			(SystemSettingID, SystemSettingName, SystemSettingDescription, DataType, DefaultValue, SystemSettingValue, SystemSettingCategoryID)
	VALUES
	(71, 'WebPlusILPStudentURL',
	'The URL of the internal app to display a StudentRef (ILP)',
	'System.String',
	'https://college.ac.uk/ILPinternal/home?AcademicYear={AcademicYear}&StudentRef={StudentRef}',
	'',
	1
	)
END
IF NOT EXISTS (SELECT 1 FROM SystemSettingValue WHERE SystemSettingName = 'WebPlusILPPreviewURL')
BEGIN
	INSERT INTO	
		SystemSettingValue
			(SystemSettingID, SystemSettingName, SystemSettingDescription, DataType, DefaultValue, SystemSettingValue, SystemSettingCategoryID)
	VALUES
	(72, 'WebPlusILPPreviewURL',
	'The URL of the internal app to preview an ILP page',
	'System.String',
	'https://college.ac.uk/ILPinternal/home/preview?pageid={PageId}&isDraft={IsDraft}',
	'',
	1
	)
END
